|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Steve Ronuken
Fuzzwork Enterprises
417
|
Posted - 2012.05.22 22:27:00 -
[1] - Quote
Kronus Heilgar wrote:MySQL port? Anyone? Anyone?
couple of hours and I'll have one ready. (hopefully) FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
417
|
Posted - 2012.05.23 10:26:00 -
[2] - Quote
I've heard that some people are getting really poor import performance with the export above. so I've also taken the one below, which might run faster for you. It's using the extended insert option, which can improve performance (With some side effects on compatibility and resumability. Probably won't affect you.)
http://www.fuzzwork.co.uk/dump/inferno10/mysql55-inferno10-extended.sql.bz2 FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
417
|
Posted - 2012.05.23 11:02:00 -
[3] - Quote
Blerg. apparently some folks are having trouble downloading from my site. So, two alternates:
http://dl.eve-files.com/media/1205/mysql55-inferno10-extended.7z https://www.dropbox.com/s/lmvbu40k1ftb5jt/mysql55-inferno10-extended.sql.bz2 FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
429
|
Posted - 2012.05.30 02:12:00 -
[4] - Quote
I've got the mysql conversion done.
So I've taken what should be a postgres compatible export from mysql. (just mysqldump with the --compatible=postgresql option)
http://www.fuzzwork.co.uk/dump/inferno10/pgsql/pgsqlcompat-inferno1.0.sql.bz2
with the following, it may work for you. Specifically the Convert and Import section. http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
438
|
Posted - 2012.06.03 18:15:00 -
[5] - Quote
The next SDE what comes out, I'll see about a PostGres conversion too. No promises, but it's likely enough to annoy me into doing it.
Anyway, for the sensitivity issue, why don't you just:
ALTER TABLE "invTypes" RENAME TO invtypes;
? There should be an easy way to list all the tables, and if it's a select statement, then you can use that statement to generate all the sql you need to run. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
438
|
Posted - 2012.06.04 16:00:00 -
[6] - Quote
http://stackoverflow.com/questions/10086532/postgresql-how-can-i-convert-all-columns-in-my-database-to-case-insensitive
\t on select 'ALTER TABLE '||'"'||table_name||'"'||' RENAME COLUMN '||'"'||column_name||'"'||' TO ' || lower(column_name)||';' from information_schema.columns where table_schema = 'public' and lower(column_name) != column_name; \g /tmp/go_to_lower \i /tmp/go_to_lower
\o /tmp/go_to_lower select 'ALTER TABLE '||'"'||tablename||'"'||' RENAME TO ' || lower(tablename)||';' from pg_tables where schemaname = 'public'; psql -U username database < /tmp/go_to_lower FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Steve Ronuken
Fuzzwork Enterprises
470
|
Posted - 2012.06.26 19:41:00 -
[7] - Quote
Oracle does much the same thing. but it uppercases everything that's not quoted. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
|
|
|